MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Purchase Orders (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 115KB | 731 lines

Consult ClarisII CLARISII Personnel Records.fp3 PERSON~1.FP3 HARDDISK \\PAULFARRAH\C CONSULT\ClarisII\v3\Personnel Records.fp3 ..\..\CONSULT\ClarisII\v3\Personnel Records.fp3 C:\CONSULT\ClarisII\v3 a[',> HBAM2016AUG95 Pro 3.0 Nz2N3 [ov5G ORDER TOTAL HBAM3016AUG95@ HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 BILL TO CITY BILL TO COMPANY BILL TO ID BILL TO NAME BILL TO STATE BILL TO STREET BILL TO ZIP CODE CREATED BY DATE CREATED DATE MODIFIED DISCOUNT DISCOUNT RATE F.O.B. EOTAL PRODUCT DESCRIPTION PRODUCT EXTENDED AMOUNT PRODUCT ID PRODUCT QUANTITY PRODUCT UNIT PRICE PURCHASE ORDER ID REQUESTED BY 5 SALES TAX SALES TAX RATE - SHIP DATE SHIP TO CITY SHIP TO COMPANY SHIP TO ID SHIP TO NAME SHIP TO STATE SHIP TO STREET SHIP TO ZIP CODE SHIP VIA SHIPPING SUBTOTAL SUPPLIER CITY SUPPLIER COMPANY SUPPLIER ID SUPPLIER STATE SUPPLIER STREET SUPPLIER ZIP CODE TERMS WEIGHT USENG.NDX Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/20/95 A Form View A List View Purchase Order Report Information Report Menu A Form ViewB Purchase Order IDB Bill To NameB DateB Bill To StreetB Bill To StateB Bill To ZIP CodeB Date CreatedB Date ModifiedB Ship To NameB Bill To CityB Bill To CompanyB Ship To CompanyB Ship To StreetB Ship To CityB Ship To StateB Ship To ZIP CodeB Product IDB Product DescriptionB Product QuantityB Product Unit PriceB +roduct QuantityB Product Unit PriceB Product Extended AmountB ) ) * SubtotalB Sales Tax RateB .A Sales TaxB 4) * ShippingB Order TotalB Discount RateB DiscountB Requested ByB 7A Ship DateB TermsB Net 30 F.O.B.B Ship ViaB Ground WeightB Created ByB Supplier CompanyB Supplier StreetB Supplier CityB Supplier State Supplier ZIP CodeB Supplier IDB Bill To IDB Ship To IDB InfoB Description Use this database file to track purchase orders. FileMaker Pro automatically calculates sales tax and product discounts. How to use this solution You can update the sales tax and discount rate by updating the values in those fields. The Purchase Order report prints a typical purchase order form. How to customize this solution You can create lookups in this file to your own product database file or even your suppliers' files. A lookup based on Product ID can find information B for Description and Price. A lookup based on Supplier Company can enter information such as the supplier's address and discount rate. A List ViewB Your Own Button Your Own Button Record Delete Record Record Reports Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Total Shipping Discount Subtotal Requested By Weight Ship Via Ship Date F.O.B. Terms Extended Amount Price Description Prod. ID Supplier P.O. No. Ship To Bill To Enter data for Purchase Orders Purchase Order ReportB TotalW Requested ByX SupplierY DateZ Order ID[ Your Own Button\ Your Own Button] Record^ Delete Record_ Record` Reportsa View As Listb View As Formc Closed Infoe2Click to see more information for a Purchase Order InformationB Your Own Button Reports View As View As Close Extended Amount Price Quantity Description Product ID Weight: Total: h Shipping: j Discount: k Subtotal: Ship Via m Ship Date F.O.B. Terms Requested By Ship To Bill To Supplier P.O. No. Purchase Order Company Name and Logo ABCE>>, << ABCF>> << ABCG>> ABCA>>, << ABAI>> << ABAK>> ABDP>>, << ABEA>> << ABEB>> Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO.Information about the Purchase Orders solutionk purchase orders. FileMaker Pro automatically calculates sales tax and product discounts. How to use this solution You can update the sales tax and discount rate by updating the values in those fields How to customize this solution You can create lookups in this file to your own product database file or even your supplier's files. O.Information about the Purchase Orders solutionn those fields How to customize this solution You can create lookups in this file to your own product database file or even your supplier's files. O.Information about the Purchase Orders solution Info for this Solution Your Own ReportB Your Own ReportC Your Own ReportD Purchase Order ReportE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Joel DavisE 05/05/95G 2301 Pennings CircleH 87154Y 5/27/95_ Lauren Petersen` Santa Fea Acme Industriesb Acme Industriesc 2301 Pennings Circled Santa Fee 87154g H107h File Storage Drawer Full Strip Stapler 3-Hole Punchi 155.3m 10.56q 147.56s 23.3u Paula Jonesw 6/25/94x Net 30y New Yorkz Ground{ 23 lbs.} Joe's Office Supply~ 1414 S. Lincoln Avenue Athens 24232 Your Own ButtonB ReportsC View As ListD View As FormE CloseF Sort by Date Sort by Supplier Sort by Requested By Purchase Order Report Open Script Sort by Date Purchase Order Report Sort by Supplier Sort by Requested By Open Script Helvetica Geneva Times Times New Roman Arial MS Sans Serif )=400 ecision ) Upper ( text ) CancelYear ( date )) WeekofYearFi cal ( date , starting day ) WordYou did not enter any find criteria; all records will be displayed.C, ) = 0 ecision ) Upper ( text ) CancelYear ( date )) WeekofYearFi cal ( date , starting day ) WordNo records match this request.E, ) = 1 wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw (LIST LISTA Ground VDEFA( Ship Via List wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFG CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7 !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww ORDER TOTAL PRODUCT DESCRIPTION PRODUCT EXTENDED AMOUNT PRODUCT ID PRODUCT QUANTITY PRODUCT UNIT PRICE PURCHASE ORDER ID REQUESTED BY 5 SALES TAX SALES TAX RATE - SHIP DATE SHIP TO CITY SHIP TO COMPANY SHIP TO ID SHIP TO NAME SHIP TO STATE SHIP TO STREET SHIP TO ZIP CODE SHIP VIA SHIPPING SUBTOTAL SUPPLIER CITY SUPPLIER COMPANY SUPPLIER ID SUPPLIER STATE SUPPLIER STREET SUPPLIER ZIP CODE TERMS WEIGHT